--SELECT * FROM personinfo
--DELETE FROM personinfo
--INSERT INTO srv_lnk.nchr2008.dbo.personinfo
SELECT top 2
Convert(int,right(id,7)) AS [ID],1 AS [UserType],FullName AS [UserID],[password] AS [UserPwd],FullName AS [FirstNameCN],Email AS [EMail],DateCreated AS [RegTime],NULL AS [CheckTime],LastSignedIn AS [LastLogin],0 AS [PasswordFlag],IsVerifiedEmail AS [IsEmailChecked],0 AS [IDChecked],0 AS [EducationChecked],Convert(int,right(id,7)) AS [CreatedUserId],DateCreated AS [CreatedDate],Convert(int,right(id,7)) AS [UpdatedUserId],LastSignedIn AS [UpdatedDate]FROM Forest.dbo.cat_jobseeker

--SELECT TOP 2 * FROM Forest.dbo.cat_jobseeker

select top 2 * from srv_lnk.nchr2008.dbo.personinfo
SELECT Convert(int,right(id,7)) FROM Forest.dbo.cat_jobseeker